-- =============================================
-- Store published location in Content_File, Content_HTML or Content.
--
-- Modifications
-- 06/16/2003      E.Tatsui
-- =============================================

CREATE       PROCEDURE amsp_CMUpdatePublishLocation
  @InContentID numeric,
  @InContentFileID numeric = 0,
  @InHTMLContentID numeric = 0,
  @InDefaultContentFlag char(1) = 'N',
  @InPublishLocation varchar(255)
AS
BEGIN
  DECLARE
    @PublishLocation varchar(255)

  SET @PublishLocation = Replace(@InPublishLocation, '\','/')

  IF @InContentFileID > 0 AND @InPublishLocation IS NOT NULL
    UPDATE Content_File
       SET PublishLocation = @PublishLocation
     WHERE ContentFileID = @InContentFileID

  IF @InHTMLContentID > 0 AND @InPublishLocation IS NOT NULL
    UPDATE Content_HTML
       SET PublishLocation = @PublishLocation
     WHERE ContentID = @InHTMLContentID

  IF @InDefaultContentFlag = 'Y' AND @InPublishLocation IS NOT NULL
    UPDATE Content
       SET PublishLocation =  @PublishLocation
     WHERE ContentID = @InContentID

END

GO
GRANT EXECUTE ON  [dbo].[amsp_CMUpdatePublishLocation] TO [IMIS]
GO